<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>SQL Formatter</title>
</head>
<body>
<form action="RenderSql" method="post"><select name="dialect">
	<option value="sql2003">SQL2003</option>
	<option value="h2">H2</option>
	<option value="hsqldb">HSQLDB</option>
	<option value="oracle">Oracle</option>
	<option value="mysql">MySQL</option>
	<option selected="selected" value="postgresql">PostgreSQL</option>
</select> <input type="submit" value="submit" /> <br />
<textarea name="sql" rows="30" cols="100">
/* 
This is some sample SQL, please edit 
or cut/paste to try the parser with 
your own SQL.  If you are using features 
like MySQL style strings ( i.e. 
'O\'Brian' ) or other feature that require 
a particular backend be sure to select the 
proper option in the drop down.
*/
create table contact (id bigint, category_id bigint, 
firstname varchar(50), lastname varchar(50), 
email varchar(100)); 
insert into contact (firstname, lastname) values ('O''Brian', 'O''Shea');
insert into contact (firstname, lastname, email) values ('Mark', 'Farnsworth', 'farnsworth2009@gmail.com');
update contact set firstname = 'Sam' where lastname = 'O''Shea';
select lastname, firstname, email from contact where lastname like 'Farns%'; 
delete from contact where lastname = 'O''Shea';
</textarea></form>
</body>
</html>